from sqlalchemy import create_engine
import pymysql
# engine = create_engine('mysql+pymysql://admin:Root123456!@192.168.18.76:=3306/hrdata?charset=utf8')
#
#
#
# #
# formlist = pd.read_sql_query('show tables', con=engine)
# print('hrdata数据库数据表清单为：\n', formlist)
conn = pymysql.connect(host='192.168.18.76',
                       port=3306,
                       passwd='Root123456!',
                       db='hrdata',
                       charset='utf8')
formlist = pd.read_sql_query('show tables', con=conn)
print('hrdata数据库数据表清单为：\n', formlist)